This section briefly describes five data types in SQL: numeric, text, numeric, logical, and date.
Character Type
Varchar and char
The differences between varchar and char data are subtle, but important. They are used to store strings of less than 255
3.3 Numeric data typesFrom the moment we open our eyes every morning, we deal with numbers almost every hour: from 6:30 on the alarm clock to the 216 bus to work, from the news that the house price fell to 100 yuan per square meter to go home to buy
3.3 Numeric data typesFrom the moment we open our eyes every morning, we deal with numbers almost every hour: from 6:30 on the alarm clock to the 216 bus to work, from the news that the house price fell to 100 yuan per square meter to go home to buy
Character and string processing functions: Character and string processing functions are all character data, but their return value types are different.1. Take the SUBSTRING function:Format: substr (C,N1,N2)Function: Take the string C N1 character
Comparison of NUMERIC and DECIMAL types in Mysql, numericdecimal
Decimal (numeric) is synonymous and used to precisely store values.
A decimal data type can store up to 38 numbers. All numbers can be placed on the right of the decimal point. The
Decimal (numeric) synonymous with the exact storage of numeric values.
The decimal data type can store up to 38 digits, and all numbers can be placed to the right of the decimal point. The decimal data type stores an accurate (accurate) numeric
Type conversion between basic types (numeric type), type conversion numeric type
As soon as I opened my blog today, I saw the 5-year-old campus in the upper left corner, and my eyes were a bit blank. The scenes of my previous class as a student have
Decimal (numeric) synonymous for precise storage of numeric valuesfloat and real cannot store values accuratelyThe decimal data type can store up to 38 digits, and all numbers can be placed to the right of the decimal point. The decimal data type
JavaScript to deal with very numeric valuesNumber (): Any data type converted to numeric value;parseint (), parsefloat (): Converts a string into a numeric value;Conversion rules:Number ():1) If it is a Boolean value, True and false are converted to
This article will introduce some of the functions that are often used in everyday life, or that are very interesting, though they are rarely used. It is divided into two kinds of introductions, namely:
Famous letters-functions that are often
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.